﻿CREATE TABLE [dbo].[aspnet_Users] (
    [UserId]                     INT            IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [UserName]                   NVARCHAR (50)  NULL,
    [Password1]                  NVARCHAR (256) NULL,
    [Password]                   NVARCHAR (256) NULL,
    [LCM_pw]                     NVARCHAR (256) CONSTRAINT [DF_aspnet_Users_LCM_pw] DEFAULT ('') NULL,
    [RTX]                        NVARCHAR (50)  NULL,
    [Email]                      NVARCHAR (50)  NULL,
    [CompanyId]                  INT            NULL,
    [Name]                       NVARCHAR (50)  NULL,
    [CreateDate]                 DATETIME       CONSTRAINT [DF_mvcUsers_CreateTime] DEFAULT (getdate()) NULL,
    [IsLockout]                  BIT            CONSTRAINT [DF_aspnet_Users_IsLockout] DEFAULT ((0)) NULL,
    [LastLoginDate]              DATETIME       NULL,
    [FailedPasswordAttemptCount] INT            CONSTRAINT [DF_aspnet_Users_FailedPasswordAttemptCount] DEFAULT ((0)) NULL,
    [IsDelete]                   BIT            CONSTRAINT [DF_aspnet_Users_IsDelete_1] DEFAULT ((0)) NULL,
    [UserInRoles]                VARCHAR (MAX)  CONSTRAINT [DF_aspnet_Users_UserInRoles_1] DEFAULT ('') NULL,
    [DepartmentId]               INT            CONSTRAINT [DF_aspnet_Users_DepartmentId_1] DEFAULT ((0)) NULL,
    [Cid]                        VARCHAR (MAX)  CONSTRAINT [DF_aspnet_Users_Cid_1] DEFAULT ('') NULL,
    [updatedate]                 DATETIME       CONSTRAINT [DF_aspnet_Users_updatedate_1] DEFAULT (getdate()) NULL,
    [updateuser]                 NVARCHAR (100) CONSTRAINT [DF_aspnet_Users_updateuser_1] DEFAULT ('') NULL,
    [DepartmentId_]              INT            CONSTRAINT [DF_aspnet_Users_DepartmentId__1] DEFAULT ((0)) NULL,
    [rootid]                     NVARCHAR (50)  CONSTRAINT [DF_aspnet_Users_rootid_1] DEFAULT ('') NULL,
    CONSTRAINT [PK_aspnet_Users] PRIMARY KEY CLUSTERED ([UserId] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'真，删除|若为假，没删除。', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'aspnet_Users', @level2type = N'COLUMN', @level2name = N'IsDelete';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'当前用户的角色 格式：[1][2][3][4]', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'aspnet_Users', @level2type = N'COLUMN', @level2name = N'UserInRoles';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'部门编号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'aspnet_Users', @level2type = N'COLUMN', @level2name = N'DepartmentId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'数据控制 用于存储公司ID 编号 [01][06]', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'aspnet_Users', @level2type = N'COLUMN', @level2name = N'Cid';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'修改时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'aspnet_Users', @level2type = N'COLUMN', @level2name = N'updatedate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'修改人', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'aspnet_Users', @level2type = N'COLUMN', @level2name = N'updateuser';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'关联账号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'aspnet_Users', @level2type = N'COLUMN', @level2name = N'rootid';

